Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Database Objects AdventureWorks
Print
RSS
Modified on 2011/08/27 11:16
by
wikibot
Categorized as
Uncategorized
dbo AccountNumber (type)
dbo AWBuildVersion (table)
dbo DatabaseLog (table)
dbo ErrorLog (table)
dbo Flag (type)
dbo Name (type)
dbo NameStyle (type)
dbo OrderNumber (type)
dbo Phone (type)
dbo ufnGetAccountingEndDate (function)
dbo ufnGetAccountingStartDate (function)
dbo ufnGetContactInformation (function)
dbo ufnGetDocumentStatusText (function)
dbo ufnGetProductDealerPrice (function)
dbo ufnGetProductListPrice (function)
dbo ufnGetProductStandardCost (function)
dbo ufnGetPurchaseOrderStatusText (function)
dbo ufnGetSalesOrderStatusText (function)
dbo ufnGetStock (function)
dbo ufnLeadingZeros (function)
dbo uspGetBillOfMaterials (procedure)
dbo uspGetEmployeeManagers (procedure)
dbo uspGetManagerEmployees (procedure)
dbo uspGetWhereUsedProductID (procedure)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
ddlDatabaseTriggerLog (database trigger)
HumanResources (schema)
HumanResources Department (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
HumanResources EmployeeDepartmentHistory (table)
HumanResources EmployeePayHistory (table)
HumanResources HRResumeSchemaCollection (xml schema collection)
HumanResources JobCandidate (table)
HumanResources Shift (table)
HumanResources uspUpdateEmployeeHireInfo (procedure)
HumanResources uspUpdateEmployeeLogin (procedure)
HumanResources uspUpdateEmployeePersonalInfo (procedure)
HumanResources vEmployee (view)
HumanResources vEmployeeDepartment (view)
HumanResources vEmployeeDepartmentHistory (view)
HumanResources vJobCandidate (view)
HumanResources vJobCandidateEducation (view)
HumanResources vJobCandidateEmployment (view)
Person (schema)
Person AdditionalContactInfoSchemaCollection (xml schema collection)
Person Address (table)
Person AddressType (table)
Person Contact (table)
Person ContactType (table)
Person CountryRegion (table)
Person StateProvince (table)
Person vAdditionalContactInfo (view)
Person vStateProvinceCountryRegion (view)
Production (schema)
Production BillOfMaterials (table)
Production Culture (table)
Production Document (table)
Production Illustration (table)
Production Location (table)
Production ManuInstructionsSchemaCollection (xml schema collection)
Production Product (table)
Production ProductCategory (table)
Production ProductCostHistory (table)
Production ProductDescription (table)
Production ProductDescriptionSchemaCollection (xml schema collection)
Production ProductDocument (table)
Production ProductInventory (table)
Production ProductListPriceHistory (table)
Production ProductModel (table)
Production ProductModelIllustration (table)
Production ProductModelProductDescriptionCulture (table)
Production ProductPhoto (table)
Production ProductProductPhoto (table)
Production ProductReview (table)
Production ProductSubcategory (table)
Production ScrapReason (table)
Production TransactionHistory (table)
Production TransactionHistoryArchive (table)
Production UnitMeasure (table)
Production vProductAndDescription (view)
Production vProductModelCatalogDescription (view)
Production vProductModelInstructions (view)
Production WorkOrder (table)
Production WorkOrderRouting (table)
Purchasing (schema)
Purchasing ProductVendor (table)
Purchasing PurchaseOrderDetail (table)
Purchasing PurchaseOrderHeader (table)
Purchasing ShipMethod (table)
Purchasing Vendor (table)
Purchasing VendorAddress (table)
Purchasing VendorContact (table)
Purchasing vVendor (view)
Sales (schema)
Sales ContactCreditCard (table)
Sales CountryRegionCurrency (table)
Sales CreditCard (table)
Sales Currency (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Individual (table)
Sales IndividualSurveySchemaCollection (xml schema collection)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesReason (table)
Sales SalesTaxRate (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales ShoppingCartItem (table)
Sales SpecialOffer (table)
Sales SpecialOfferProduct (table)
Sales Store (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vIndividualCustomer (view)
Sales vIndividualDemographics (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
dbo AccountNumber (type)
dbo AWBuildVersion (table)
dbo DatabaseLog (table)
dbo ErrorLog (table)
dbo Flag (type)
dbo Name (type)
dbo NameStyle (type)
dbo OrderNumber (type)
dbo Phone (type)
dbo ufnGetAccountingEndDate (function)
dbo ufnGetAccountingStartDate (function)
dbo ufnGetContactInformation (function)
dbo ufnGetDocumentStatusText (function)
dbo ufnGetProductDealerPrice (function)
dbo ufnGetProductListPrice (function)
dbo ufnGetProductStandardCost (function)
dbo ufnGetPurchaseOrderStatusText (function)
dbo ufnGetSalesOrderStatusText (function)
dbo ufnGetStock (function)
dbo ufnLeadingZeros (function)
dbo uspGetBillOfMaterials (procedure)
dbo uspGetEmployeeManagers (procedure)
dbo uspGetManagerEmployees (procedure)
dbo uspGetWhereUsedProductID (procedure)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
ddlDatabaseTriggerLog (database trigger)
HumanResources (schema)
HumanResources Department (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
HumanResources EmployeeDepartmentHistory (table)
HumanResources EmployeePayHistory (table)
HumanResources HRResumeSchemaCollection (xml schema collection)
HumanResources JobCandidate (table)
HumanResources Shift (table)
HumanResources uspUpdateEmployeeHireInfo (procedure)
HumanResources uspUpdateEmployeeLogin (procedure)
HumanResources uspUpdateEmployeePersonalInfo (procedure)
HumanResources vEmployee (view)
HumanResources vEmployeeDepartment (view)
HumanResources vEmployeeDepartmentHistory (view)
HumanResources vJobCandidate (view)
HumanResources vJobCandidateEducation (view)
HumanResources vJobCandidateEmployment (view)
Person (schema)
Person AdditionalContactInfoSchemaCollection (xml schema collection)
Person Address (table)
Person AddressType (table)
Person Contact (table)
Person ContactType (table)
Person CountryRegion (table)
Person StateProvince (table)
Person vAdditionalContactInfo (view)
Person vStateProvinceCountryRegion (view)
Production (schema)
Production BillOfMaterials (table)
Production Culture (table)
Production Document (table)
Production Illustration (table)
Production Location (table)
Production ManuInstructionsSchemaCollection (xml schema collection)
Production Product (table)
Production ProductCategory (table)
Production ProductCostHistory (table)
Production ProductDescription (table)
Production ProductDescriptionSchemaCollection (xml schema collection)
Production ProductDocument (table)
Production ProductInventory (table)
Production ProductListPriceHistory (table)
Production ProductModel (table)
Production ProductModelIllustration (table)
Production ProductModelProductDescriptionCulture (table)
Production ProductPhoto (table)
Production ProductProductPhoto (table)
Production ProductReview (table)
Production ProductSubcategory (table)
Production ScrapReason (table)
Production TransactionHistory (table)
Production TransactionHistoryArchive (table)
Production UnitMeasure (table)
Production vProductAndDescription (view)
Production vProductModelCatalogDescription (view)
Production vProductModelInstructions (view)
Production WorkOrder (table)
Production WorkOrderRouting (table)
Purchasing (schema)
Purchasing ProductVendor (table)
Purchasing PurchaseOrderDetail (table)
Purchasing PurchaseOrderHeader (table)
Purchasing ShipMethod (table)
Purchasing Vendor (table)
Purchasing VendorAddress (table)
Purchasing VendorContact (table)
Purchasing vVendor (view)
Sales (schema)
Sales ContactCreditCard (table)
Sales CountryRegionCurrency (table)
Sales CreditCard (table)
Sales Currency (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Individual (table)
Sales IndividualSurveySchemaCollection (xml schema collection)
Sales SalesOrderDetail (table)
Sales SalesOrderHeader (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesReason (table)
Sales SalesTaxRate (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales ShoppingCartItem (table)
Sales SpecialOffer (table)
Sales SpecialOfferProduct (table)
Sales Store (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vIndividualCustomer (view)
Sales vIndividualDemographics (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
»
Database Objects AdventureWorks
[X]
»
Database Objects AdventureWorks
wikibot
¶
adventureworks (mie60)
Tables
¶
Address (Person)
AddressType (Person)
AWBuildVersion (dbo)
BillOfMaterials (Production)
Contact (Person)
ContactCreditCard (Sales)
ContactType (Person)
CountryRegion (Person)
CountryRegionCurrency (Sales)
CreditCard (Sales)
Culture (Production)
Currency (Sales)
CurrencyRate (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources)
Document (Production)
Employee (HumanResources)
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ErrorLog (dbo)
Illustration (Production)
Individual (Sales)
JobCandidate (HumanResources)
Location (Production)
Product (Production)
ProductCategory (Production)
ProductCostHistory (Production)
ProductDescription (Production)
ProductDocument (Production)
ProductInventory (Production)
ProductListPriceHistory (Production)
ProductModel (Production)
ProductModelIllustration (Production)
ProductModelProductDescriptionCulture (Production)
ProductPhoto (Production)
ProductProductPhoto (Production)
ProductReview (Production)
ProductSubcategory (Production)
ProductVendor (Purchasing)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderDetail (Sales)
SalesOrderHeader (Sales)
SalesOrderHeaderSalesReason (Sales)
SalesPerson (Sales)
SalesPersonQuotaHistory (Sales)
SalesReason (Sales)
SalesTaxRate (Sales)
SalesTerritory (Sales)
SalesTerritoryHistory (Sales)
ScrapReason (Production)
Shift (HumanResources)
ShipMethod (Purchasing)
ShoppingCartItem (Sales)
SpecialOffer (Sales)
SpecialOfferProduct (Sales)
StateProvince (Person)
Store (Sales)
StoreContact (Sales)
TransactionHistory (Production)
TransactionHistoryArchive (Production)
UnitMeasure (Production)
Vendor (Purchasing)
VendorAddress (Purchasing)
VendorContact (Purchasing)
WorkOrder (Production)
WorkOrderRouting (Production)
Views
¶
vAdditionalContactInfo (Person)
vEmployee (HumanResources)
vEmployeeDepartment (HumanResources)
vEmployeeDepartmentHistory (HumanResources)
vIndividualCustomer (Sales)
vIndividualDemographics (Sales)
vJobCandidate (HumanResources)
vJobCandidateEducation (HumanResources)
vJobCandidateEmployment (HumanResources)
vProductAndDescription (Production)
vProductModelCatalogDescription (Production)
vProductModelInstructions (Production)
vSalesPerson (Sales)
vSalesPersonSalesByFiscalYears (Sales)
vStateProvinceCountryRegion (Person)
vStoreWithDemographics (Sales)
vVendor (Purchasing)
Procedures
¶
uspGetBillOfMaterials (dbo)
uspGetEmployeeManagers (dbo)
uspGetManagerEmployees (dbo)
uspGetWhereUsedProductID (dbo)
uspLogError (dbo)
uspPrintError (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)
Functions
¶
ufnGetAccountingEndDate (dbo)
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductListPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)
ufnGetSalesOrderStatusText (dbo)
ufnGetStock (dbo)
ufnLeadingZeros (dbo)
ufnGetContactInformation (dbo)
Schemas
¶
HumanResources
Person
Production
Purchasing
Sales
Types
¶
AccountNumber (dbo)
Flag (dbo)
Name (dbo)
NameStyle (dbo)
OrderNumber (dbo)
Phone (dbo)
XML Schema Collections
¶
AdditionalContactInfoSchemaCollection (Person)
HRResumeSchemaCollection (HumanResources)
IndividualSurveySchemaCollection (Sales)
ManuInstructionsSchemaCollection (Production)
ProductDescriptionSchemaCollection (Production)
StoreSurveySchemaCollection (Sales)
Database Triggers
¶
ddlDatabaseTriggerLog
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.